package cc.admin.modules.wea.mapper;

import java.util.List;

import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import org.apache.ibatis.annotations.Param;
import cc.admin.modules.wea.entity.WeaWarningRecord;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Select;

/**
 * @Description: 预警历史表
 * @Author: cc-admin
 * @Date:   2024-08-30
 * @Version: V1.0.0
 */
public interface WeaWarningRecordMapper extends BaseMapper<WeaWarningRecord> {
    @Select("SELECT r.id,p.name as platformId,r.warning_detail_id,r.create_time,r.tenant_id " +
            "from wea_warning_record as r " +
            "JOIN wea_platform as p ON r.platform_id = p.id ")
    IPage<WeaWarningRecord> getPlatName(Page<WeaWarningRecord> page);
}
